/*
 Navicat Premium Data Transfer

 Source Server         : 阿里云服务器：SQL Server
 Source Server Type    : SQL Server
 Source Server Version : 13005026
 Source Host           : 121.40.101.29:1433
 Source Catalog        : scm_main_sfl_visit_dev
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 13005026
 File Encoding         : 65001

 Date: 21/09/2020 17:16:06
*/


-- ----------------------------
-- Table structure for bd_sys_item
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[bd_sys_item]') AND type IN ('U'))
	DROP TABLE [dbo].[bd_sys_item]
GO

CREATE TABLE [dbo].[bd_sys_item] (
  [id] int  NOT NULL,
  [bh] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [type_id] int  NULL,
  [name] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[bd_sys_item] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of [bd_sys_item]
-- ----------------------------
INSERT INTO [dbo].[bd_sys_item]  VALUES (N'1', N'1000001', N'38', N'平时加班')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'2', N'1000002', N'38', N'周末')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'3', N'1000003', N'38', N'法定节假日加班')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'4', N'1000004', N'38', N'加班转调休')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'5', N'1000005', N'38', N'加班不计工时')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'10', N'10', N'39', N'上级主管/车间')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'11', N'11', N'39', N'物流')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'12', N'12', N'39', N'部门总监')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'13', N'13', N'39', N'HR')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'14', N'14', N'39', N'总经理')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'15', N'15', N'39', N'工会')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'16', N'16', N'39', N'一级审批')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'17', N'17', N'39', N'二级审批')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'20', N'20', N'40', N'普通员工')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'21', N'21', N'40', N'弹性工作制')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'22', N'22', N'40', N'部门总监')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'23', N'23', N'40', N'高层领导')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'24', N'24', N'40', N'外包长期供应商')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'30', N'30', N'41', N'办公室员工')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'31', N'31', N'41', N'生产线员工')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'32', N'32', N'41', N'生产线外包人员')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'33', N'33', N'41', N'外包长期供应商')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'34', N'34', N'41', N'临时访客')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'35', N'35', N'41', N'短期供应商现场人员')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'36', N'36', N'41', N'非生产线外包人员')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'37', N'37', N'41', N'高层领导')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'100', N'10001', N'200', N'安亭基地')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'120', N'10001', N'201', N'身份证')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'121', N'10002', N'201', N'驾驶证')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'122', N'10003', N'201', N'护照')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'140', N'10001', N'202', N'商务洽谈')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'141', N'10002', N'202', N'业务办理')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'142', N'10003', N'202', N'其他')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'160', N'10001', N'203', N'短期访客')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'161', N'10002', N'203', N'常驻访客')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'162', N'10003', N'203', N'其他')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'50000', N'50000', N'61', N'早早班')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'50001', N'50001', N'61', N'早班')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'50002', N'50002', N'61', N'中班')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'50003', N'50003', N'61', N'日8进8出')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'50004', N'50004', N'61', N'夜班')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'50005', N'50005', N'61', N'夜8进8出')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'50006', N'50006', N'61', N'早中')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'50007', N'50007', N'61', N'中夜')
GO

INSERT INTO [dbo].[bd_sys_item]  VALUES (N'50008', N'50008', N'61', N'测试班次类型-22')
GO


-- ----------------------------
-- Primary Key structure for table bd_sys_item
-- ----------------------------
ALTER TABLE [dbo].[bd_sys_item] ADD CONSTRAINT [PK_BD_SYS_ITEM] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO

